

/* clean up names from corelogic  */

if "`1'"=="" {
	
	replace seller = "AMERICASFIRST" if substr(seller,1,13)=="AMERICASFIRST"
	replace seller = "ARBOR" if substr(seller,1,5)=="ARBOR" & PROPERTY_STATE=="IN"
	replace seller = "ARMADILLO" if substr(seller,1,9)=="ARMADILLO"
	replace seller = "ANGLIA" if seller=="ANGLIALP"
	replace seller = "AV" if seller=="AVATAR" | seller=="AV(FORMERLYAVATAR)"
	replace seller = "BALL" if seller=="BALLHMS" 
	replace seller = "BOWENFAMILY" if seller=="BOWENBUILDERS" | substr(seller,1,9)=="BOWENBLDR" | substr(seller,1,11)=="BOWENFAMILY"
	replace seller = "CAPITALPACIFIC" if substr(seller,1,14)=="CAPITALPACIFIC"
	replace seller = "CASALINDA" if substr(seller,1,9)=="CASALINDA"
	replace seller = "CHESMAR" if substr(seller,1,7)=="CHESMAR"
	replace seller = "DESERTVIEW" if substr(seller,1,10)=="DESERTVIEW"
	replace seller = "DRHORTON" if seller=="CONTINENTALTEXAS"
	replace seller = "EASTWOOD" if seller=="EASTWOODCO" | seller=="EASTWOODRALEIGH" | seller=="EASTWOODSTAUGUSTINE"
	replace seller = "ELLIOTT" if seller=="ELLIOTTARIZONA" | seller=="ELLIOTTHMS" | seller=="ELLIOTTRESIDENTIAL"
	replace seller = "FIELDSTONECOMMUNITIES" if substr(seller,1,16)=="FIELDSTONECOMMUN" & PROPERTY_STATE=="CA"
	replace seller = "HAYDEN" if seller=="HAYDENENTS" | seller=="HAYDENENTERPRISES" | seller=="HAYDENENT" | seller=="HAYDENCO" | seller=="HAYDENIDAHO"
	replace seller = "HEARTLAND" if substr(seller,1,9)=="HEARTLAND" & year<2013  
	replace seller = "NVR" if seller=="RYAN" | seller=="FOXRIDGE"  // subsidiaries of nvr
	replace seller = "HOLIDAYBUILDERS" if substr(seller,1,8)=="HOLIDAYB" | regexm(seller,"HOLIDAYBUILDER")==1
	replace seller = "IVORY" if substr(seller,1,5)=="IVORY" & PROPERTY_STATE=="UT"
	replace seller = "KB" if seller=="KAUFMAN&BROAD" | substr(seller,1,13)=="KAUFMAN&BROAD" | substr(seller,1,15)=="KAUFMANANDBROAD"
	replace seller = "LENNAR" if seller=="GREYSTONE" | seller=="US" & year>2000 | seller=="US HOME CORP"  // this is subs
	replace seller = "MARONDA" if substr(seller,1,7)=="MARONDA"
	replace seller = "MERCEDES" if substr(seller,1,9)=="MERCEDEST" | substr(seller,1,10)=="MERCEDESHM"
	replace seller = "MERITAGE" if substr(seller,1,4)=="MTH-"
	replace seller = "M/I" if regexm(seller,"SCHOTTENSTEIN")==1
	replace seller = "MINTOCOMMUNITIES" if substr(seller,1,8)=="MINTOCOM"
	replace seller = "MONTALBANOBUILDERS" if substr(seller,1,10)=="MONTALBANO"
	
	
	
	
	
	
	replace seller = "AV" if substr(seller,1,6)=="AVATAR"
	replace seller = "MERCEDES" if substr(seller,1,8)=="MERCEDES"   
	replace seller = "TOUSA" if substr(seller,1,7)=="NEWMARK" | substr(seller,1,6)=="TROPHY"
	replace seller = "DRHORTON" if substr(seller,1,21)=="WESTERNPACIFICHOUSING"
	replace seller = "MERITAGE" if regexm(seller,"LEGACY")==1 & regexm(seller,"MONTEREY")==1
	replace seller = "HOVNANIAN" if substr(seller,1,12)=="FIRSTBUILDER"
	replace seller = "TOUSA" if substr(seller,1,16)=="TECHNICALOLYMPIC"
	replace seller = "TOUSA" if regexm(seller,"TRANSEASTERN")==1
	replace seller = "PULTE" if substr(seller,1,7)=="WEBBDEL"
	replace seller = "ADAMS" if regexm(seller,"ADAMS")==1 & regexm(seller,"NORTHWEST")==1 | substr(seller,1,10)=="ADAMSNORTH"
	replace seller = "HOVNANIAN" if substr(seller,1,13)=="GOODMANFAMILY"
	replace seller = "CBH" if substr(seller,1,11)=="COREYBARTON"
	replace seller = "ORLEANS" if substr(seller,1,8)=="ROTTLUND" & year>2001 
	replace seller = "ORLEANS" if regexm(seller,"PARKER")==1 & regexm(seller,"ORLEANS")==1
	replace seller = "CROSSMANN" if substr(seller,1,9)=="CROSSMANN" & year<2003
	replace seller = "BEAZER" if substr(seller,1,9)=="CROSSMANN" & year>=2003
	replace seller = "DRHORTON" if substr(seller,1,3)=="DRH"
	replace seller = "HISTORYMAKER" if seller == "HMHLIFESTYLES"
	replace seller = "PULTE" if substr(seller,1,4)=="OBRA" & year>=2003
	replace seller = "OBRA" if substr(seller,1,4)=="OBRA" & year<2003
	replace seller = "HOVNANIAN" if substr(seller,1,9)=="NEWFORTIS"
	replace seller = "DRHORTON" if seller=="MELODY"
	replace seller = "TAYLORWOODROW" if substr(seller,1,2) == "TW"
	replace seller = "LENNAR" if substr(seller,1,15)=="VILLAGEBUILDERS"
	replace seller = "DRHORTON" if seller=="KDB"
	replace seller = "ELITEPROPSAMERICA" if seller=="CLASSIC"
	replace seller = "TURNBERRYMGMGRAND" if regexm(seller,"TURNBERRYMGMGRAND")==1
	replace seller = "RYLAND" if seller=="TREND" & year>=2012
	replace seller = "WILLIAMLYON" if year>=2012 & seller=="VILLAGECOLORAD" | seller=="VILLAGELORADO"
	replace seller = "MERITAGE" if seller=="MONTEREYARIZONA" & year>2007
	replace seller = "CALATLANTIC" if seller=="WESTFIELD"  & year>=2002
	replace seller = "LENNAR" if seller=="USHM" 
	replace seller = "CELEBRITY" if seller=="HEARTHSTONE" & year>=2012
	replace seller = "ASHTONWOODS" if substr(seller,1,6)=="ASHTON"
	replace seller = "SHEA" if substr(seller,1,4)=="SHEA" 
	
	
	replace seller = "DOVER" if regexm(seller,"DOVER")==1 & regexm(seller,"INVESTMENT")==1
	replace seller = "GREENBRICK" if substr(seller,1,10)=="GREENBRICK"
	replace seller = "CALIFORNIACOASTAL" if substr(seller,1,15)=="CALIFORNIACOAST"
	replace seller = "ENGEL" if substr(seller,1,5)=="ENGEL"
	replace seller = "FIRSTCINCINNATI" if substr(seller,1,6)=="ZARING"
	replace seller = "UCP" if seller=="BENCHMARK"
	
	
	
	
	
	
	replace seller = "NEUMANN" if seller=="NEUMANNCOLORADO" | seller=="NEUMANNMICHIGAN" | seller=="NEUMANNWI" | seller=="NEUMANNWISCONSIN" 
	replace seller = "NEWMARKHOUSTON" if substr(seller,1,7)=="NEWMARK"
	replace seller = "ROYCE" if seller=="ROYCELP" | seller=="ROYCEATLANTA" | seller=="ROYCEDALLAS"
	replace seller = "SARATOGA" if substr(seller,1,8)=="SARATOGA" & PROPERTY_STATE=="TX" 
	replace seller = "STYLECRAFT" if substr(seller,1,10)=="STYLECRAFT"
	replace seller = "TRIPOINTE" if seller=="QUADRANT" | substr(seller,1,7)=="MARACAY" & PROPERTY_STATE=="AZ"  | seller=="TRENDMAKER" 
	replace seller = "TH" if substr(seller,1,3)=="TH "
	replace seller = "TOUSA" if substr(seller,1,5)=="ENGLE"
	replace seller = "WESTPORT" if substr(seller,1,8)=="WESTPORT" & PROPERTY_STATE=="IN" | substr(seller,1,8)=="WESTPORT" & PROPERTY_STATE=="OH"
	replace seller = "MHI" if substr(seller,1,8)=="WILSHIRE" & PROPERTY_STATE=="TX"

	
	
	replace seller = "ARMADILLO" if seller=="ARMADILLCO" | seller=="ARMADILLOCOAUSTIN" | seller=="ARMADILLOCOHOUSTON" | seller=="ARMADILLOCOMPANY" | seller=="ARMADILLOCOMPANYAUSTIN" | seller=="ARMADILLOCONSTRUCTIONCO" ///
		| seller=="ARMADILLOCONSTAUSTIN" | seller=="ARMADILLOCONSTCO" | seller=="ARMADILLOCONSTRUCTIONCO"  | seller=="ARMADILLOS" | seller=="ARMADILLOSCO" | seller=="ARMADILLOSCOHOU"
	replace seller="ASHTONWOODS" if "ASHTONWOODS"==substr(seller,1,11) 		
	replace seller="AV" if substr(seller,1,5)=="AVHMS" | substr(seller,1,6)=="AVATAR" | substr(seller,1,8)=="BONTERRA" | substr(seller,1,9)=="ROYALOAKS" & PROPERTY_STATE=="NC"
	replace seller="BLOOMFIELD" if seller=="BLOOMFIELDEQUITY" & PROPERTY_STATE=="TX" | seller=="BLOOMFIELDLP" & PROPERTY_STATE=="TX"
	replace seller = "CASTLEROCKCOMMUNITIES" if seller=="CASTLEROCKCOMMUNITIESLP" & PROPERTY_STATE=="TX"
	replace seller = "CALATLANTIC" if substr(seller,1,10)=="CENTERLINE" & year>=2013 & PROPERTY_STATE=="FL" | seller=="STANDARDPACIFIC"
	replace seller = "CENTERLINE" if substr(seller,1,10)=="CENTERLINE" & year<2013 & PROPERTY_STATE=="FL"
	replace seller = "CHELDAN" if substr(seller,1,7)=="CHELDAN"
	replace seller = "CPMORGAN" if substr(seller,1,8)=="CPMORGAN"
	replace seller = "CRAFTMARK" if substr(seller,1,9)=="CRAFTMARK"
	replace seller = "DANRYAN" if substr(seller,1,7)=="DANRYAN"
	replace seller = "DARLING" if seller=="DARLINGHOUSTON" & year<2012 | seller=="DARLINGTEXAS" & year<2012 | seller=="DARLINGDALLAS" & year<2012 ///
		| substr(seller,1,8)=="DARLINGH" & year<2012
	replace seller = "TAYLORMORRISON" if seller=="DARLING" & year>=2012
	replace seller = "WEEKLEY" if substr(seller,1,12)=="DAVIDWEEKLEY" | substr(seller,1,7)=="WEEKLEY"
	
	replace seller = "DREES" if regexm(seller,"DREES")==1
	replace seller = "FIELDSTONE" if substr(seller,1,10)=="FIELDSTONE" & PROPERTY_STATE=="UT"
	replace seller = "FISCHER" if substr(seller,1,14)=="FISCHERATTACHED" | substr(seller,1,16)=="FISCHERSINGLEFAM"
	replace seller = "FULTON" if substr(seller,1,10)=="FULTONSALE"
	replace seller = "GEMCRAFT" if substr(seller,1,8)=="GEMCRAFT"
	replace seller = "GL" if substr(seller,1,5)=="GLHMS"
	replace seller = "GRAND" if substr(seller,1,7)=="GRAND20"
	replace seller = "H&H" if seller=="H&HCONSTRUCTORS" | seller=="H&HFAYETTEVILLE" | substr(seller,1,3)=="H&H" & PROPERTY_STATE=="NC"
	replace seller = "HARMONY" if substr(seller,1,7)=="HARMONY"
	replace seller = "HHHUNT" if substr(seller,1,6)=="HHHUNT"
	replace seller = "HIGHLAND" if seller=="HIGHLAND-AUSTIN" | seller=="HIGHLAND-HOUSTON" | seller =="HIGHLAND-SANANTONIO"
	replace seller = "HILLSCOMMUNITIES" if substr(seller,1,16)=="HILLSCOMMUNITIES"
	replace seller = "HOVNANIAN" if substr(seller,1,7)=="KHOVNAN"
	replace seller = "ICI" if substr(seller,1,3)=="ICI"
	replace seller = "IDEAL" if substr(seller,1,11)=="IDEALNORMAN"
	replace seller = "KEYSTONECUSTOM" if seller=="KEYSTONEDEVCO" 
	replace seller = "KIMBALLHILL" if substr(seller,1,11)=="KIMBALLHILL"
	replace seller = "LAKEWOOD" if  substr(seller,1,8)=="LAKEWOOD" & PROPERTY_STATE=="IL"
	replace seller = "LANDON" if seller=="LANDONLP"
	replace seller = "LOMBARDO" if substr(seller,1,8)=="LOMBARDO"
	replace seller = "MATTAMY" if substr(seller,1,7)=="MATTAMY" | substr(seller,1,7)=="MONARCH"
	replace seller = "MCCAR" if seller=="MCCARRALEIGH" | seller=="MCCARBUILDERS" | seller=="MCCARHMS" | seller=="MCCARDEV" ///
		| seller=="MCCARDEVELOPMENT" | substr(seller,1,6)=="MCCAR-"
	replace seller = "MDC" if substr(seller,1,15)=="RICHMONDAMERICA"
	replace seller = "MHI" if substr(seller,1,3)=="MHI" | substr(seller,1,8)=="WILSHIRE" | substr(seller,1,8)=="COVENTRY" & PROPERTY_STATE=="TX" ///
		| substr(seller,1,10)=="PLANTATION" & PROPERTY_STATE=="TX"

	replace seller = "NOVARE" if substr(seller,1,6)=="NOVARE" & PROPERTY_STATE=="NC" | substr(seller,1,6)=="NOVARE" & PROPERTY_STATE=="GA"
	replace seller = "ORLEANS" if substr(seller,1,7)=="ORLEANS"
	replace seller = "PEACHTREECOMMUNITIES" if substr(seller,1,9)=="PEACHTREE" & year<=2014
	replace seller = "CENTURYCOMMUNITIES" if substr(seller,1,9)=="PEACHTREE" & year>2014
	replace seller = "RAUSCHCOLEMAN" if substr(seller,1,13)=="RAUSCHCOLEMAN" 
	replace seller = "S&A" if substr(seller,1,3)=="S&A"
	replace seller = "SHEA" if substr(seller,1,6)=="JFSHEA" | seller=="SHEAREALESTATEINVS" | seller=="SHEALP" | seller=="SHEALIMITEDPARTNER" ///
		| seller=="SHEALAQUINTA" | seller=="SHEAHMSLP" | seller=="SHEAHMS" | seller=="SHEACOMMUNITIESMARKETING " ///
		| seller=="SHEAARIZONA" | seller=="SHEAARIZONALP"  | seller== "SHEAARIZONALIMITED" | seller=="SHEAATMONTAGE" ///
		| seller=="SHEA-HOLLISTER" | seller=="SHEACOMM&POWERRANCHMARKETING" | seller=="SHEACOMMATPOWERRANCH" ///
		| seller=="SHEAPHOENIX" | seller=="SHEAMONTAGE" | seller=="SHEAREALESTATEINVS" | seller=="SHEASOUTHWEST" ///
		| seller=="SHEAVICTORIAGARDENS" | seller=="SHEARIVERPARKDEVELOPERS"
	replace seller = "SHUGARTENTERPRISES" if seller=="SHUGARTENTS" | seller=="SHUGARTMANAGEMENT"
	replace seller = "SIGNATURE" if substr(seller,1,9)=="SIGNATURE"  & PROPERTY_STATE=="AL" ///
		| substr(seller,1,9)=="SIGNATURE" & PROPERTY_STATE=="TN"
	replace seller = "SIMMONS" if substr(seller,1,9)=="SIMMONSHM" & PROPERTY_STATE=="OK" | substr(seller,1,10)=="SIMMONSRES" & PROPERTY_STATE=="OK"  
	replace seller = "SMITHDOUGLASCOMMUNITIES" if substr(seller,1,14)=="SMITHDOUGHLASHM"
	replace seller = "STANDARDPACIFIC" if substr(seller,1,15)=="STANDARDPACIFIC"
	replace seller = "SUMMERHILL" if substr(seller,1,10)=="SUMMERHILL" & PROPERTY_STATE=="CA"
	replace seller = "TAYLORMORRISON" if substr(seller,1,14)=="TAYLORMORRISON" | seller=="DARLINGHOUSTON" & year>=2012 | seller=="DARLINGTEXAS" & year>=2012 | seller=="DARLINGDALLAS" & year>=2012 ///
		| substr(seller,1,8)=="DARLINGH" & year>=2012 | substr(seller,1,8)=="MORRISON" & year>2008 | ///
		substr(seller,1,13)=="TAYLORWOODROW" & year>2008
	replace seller = "MORRISON" if substr(seller,1,8)=="MORRISON" & year<=2008
	replace seller = "TAYLORWOODROW" if substr(seller,1,13)=="TAYLORWOODROW" & year<=2008
	replace seller = "THEKNIGHT" if substr(seller,1,9)=="THEKNIGHT" & PROPERTY_STATE=="GA" | seller=="KNIGHT" & PROPERTY_STATE=="GA" /// 
		| seller=="KNIGHTGRP" & PROPERTY_STATE=="GA"
	replace seller = "TOLLBROTHERS" if substr(seller,1,6)=="TOLLCA" | substr(seller,1,8)=="TOLLLAND" | substr(seller,1,10)=="TOLLDALLAS" ///
		| substr(seller,1,9)=="TOLLSOUTH" | substr(seller,1,13)=="RANCHOCOSTERA" | substr(seller,1,8)=="TOLLHOUS" ///
		| substr(seller,1,9)=="DOLINGTON" | substr(seller,1,14)=="COLDSPRINGHUNT" | substr(seller,1,17)=="WATERFORDPRESERVE"  ///
		|  substr(seller,1,3)=="TBI" | substr(seller,1,7)=="SHAPELL"
	replace seller = "TRUEUSA" if substr(seller,1,4)=="TRUE" & PROPERTY_STATE=="NC" | substr(seller,1,4)=="TRUE" & PROPERTY_STATE=="SC"  ///
		| seller=="CRAFT" & PROPERTY_STATE=="NC" | seller=="CRAFT" & PROPERTY_STATE=="SC" |  seller=="CRAFTUSA" & PROPERTY_STATE=="NC"  ///
		| seller=="CRAFTUSA" & PROPERTY_STATE=="SC" 
	replace seller = "UNITED-BUILT" if  substr(seller,1,8)=="UNITED-B"
	replace seller = "WESTHILLSDEVELOPMENT" if substr(seller,1,12)=="WESTHILLSDEV"
	replace seller = "WESTIN" if substr(seller,1,6)=="WESTIN" & PROPERTY_STATE=="TX"
	replace seller = "WILLIAMLYON" if substr(seller,1,11)=="WILLIAMLYON"
	replace seller = "WILLIAMRYAN" if substr(seller,1,11)=="WILLIAMRYAN"
	replace seller = "WL" if substr(seller,1,9)=="JOHNLAING" | seller=="WATT" | substr(seller,1,5)=="WATT-"
	replace seller = "WOODSIDE" if substr(seller,1,8)=="WOODSIDE" & PROPERTY_STATE=="AZ" | substr(seller,1,8)=="WOODSIDE" & PROPERTY_STATE=="CA" ///
			| substr(seller,1,8)=="WOODSIDE" & PROPERTY_STATE=="UT" | substr(seller,1,8)=="WOODSIDE" & PROPERTY_STATE=="NV" ///
			| substr(seller,1,8)=="WOODSIDE" & PROPERTY_STATE=="TX" 
}		
if "`1'"=="topbuilder" {

	replace seller = "AMERICASFIRST" if substr(seller,1,13)=="AMERICASFIRST"
	replace seller = "ARBOR" if substr(seller,1,5)=="ARBOR" 
	replace seller = "ARMADILLO" if substr(seller,1,9)=="ARMADILLO"
	replace seller = "ANGLIA" if seller=="ANGLIALP"
	replace seller = "AV" if seller=="AVATAR" | seller=="AV(FORMERLYAVATAR)"
	replace seller = "BALL" if seller=="BALLHMS" 
	replace seller = "BOWENFAMILY" if seller=="BOWENBUILDERS" | substr(seller,1,9)=="BOWENBLDR" | substr(seller,1,11)=="BOWENFAMILY"
	replace seller = "CAPITALPACIFIC" if substr(seller,1,14)=="CAPITALPACIFIC"
	replace seller = "CASALINDA" if substr(seller,1,9)=="CASALINDA"
	replace seller = "CHESMAR" if substr(seller,1,7)=="CHESMAR"
	replace seller = "DESERTVIEW" if substr(seller,1,10)=="DESERTVIEW"
	replace seller = "DRHORTON" if seller=="CONTINENTALTEXAS"
	replace seller = "EASTWOOD" if seller=="EASTWOODCO" | seller=="EASTWOODRALEIGH" | seller=="EASTWOODSTAUGUSTINE"
	replace seller = "ELLIOTT" if seller=="ELLIOTTARIZONA" | seller=="ELLIOTTHMS" | seller=="ELLIOTTRESIDENTIAL"
	replace seller = "FIELDSTONECOMMUNITIES" if substr(seller,1,16)=="FIELDSTONECOMMUN" 
	replace seller = "HAYDEN" if seller=="HAYDENENTS" | seller=="HAYDENENTERPRISES" | seller=="HAYDENENT" | seller=="HAYDENCO" | seller=="HAYDENIDAHO"
	replace seller = "HEARTLAND" if substr(seller,1,9)=="HEARTLAND" & year<2013  
	replace seller = "NVR" if seller=="RYAN" | seller=="FOXRIDGE"  // subsidiaries of nvr
	replace seller = "HOLIDAYBUILDERS" if substr(seller,1,8)=="HOLIDAYB" | regexm(seller,"HOLIDAYBUILDER")==1
	replace seller = "IVORY" if substr(seller,1,5)=="IVORY" 
	replace seller = "KB" if seller=="KAUFMAN&BROAD" | substr(seller,1,13)=="KAUFMAN&BROAD" | substr(seller,1,15)=="KAUFMANANDBROAD"
	replace seller = "LENNAR" if seller=="GREYSTONE" | seller=="US"  & year>2000  | seller=="US HOME CORP"   // this is subs
	replace seller = "MARONDA" if substr(seller,1,7)=="MARONDA"
	replace seller = "MERCEDES" if substr(seller,1,9)=="MERCEDEST" | substr(seller,1,10)=="MERCEDESHM"
	replace seller = "MERITAGE" if substr(seller,1,4)=="MTH-"
	replace seller = "M/I" if regexm(seller,"SCHOTTENSTEIN")==1
	replace seller = "MINTOCOMMUNITIES" if substr(seller,1,8)=="MINTOCOM"
	replace seller = "MONTALBANOBUILDERS" if substr(seller,1,10)=="MONTALBANO"
	
	
	
	replace seller = "AV" if substr(seller,1,6)=="AVATAR"
	replace seller = "MERCEDES" if substr(seller,1,8)=="MERCEDES"   
	replace seller = "TOUSA" if substr(seller,1,7)=="NEWMARK" | substr(seller,1,6)=="TROPHY"
	replace seller = "DRHORTON" if substr(seller,1,21)=="WESTERNPACIFICHOUSING"
	replace seller = "MERITAGE" if regexm(seller,"LEGACY")==1 & regexm(seller,"MONTEREY")==1
	replace seller = "HOVNANIAN" if substr(seller,1,12)=="FIRSTBUILDER"
	replace seller = "TOUSA" if substr(seller,1,16)=="TECHNICALOLYMPIC"
	replace seller = "TOUSA" if regexm(seller,"TRANSEASTERN")==1
	replace seller = "PULTE" if substr(seller,1,7)=="WEBBDEL"
	replace seller = "ADAMS" if regexm(seller,"ADAMS")==1 & regexm(seller,"NORTHWEST")==1 | substr(seller,1,10)=="ADAMSNORTH"
	replace seller = "HOVNANIAN" if substr(seller,1,13)=="GOODMANFAMILY"
	replace seller = "CBH" if substr(seller,1,11)=="COREYBARTON"
	replace seller = "ORLEANS" if substr(seller,1,8)=="ROTTLUND" & year>2001 
	replace seller = "ORLEANS" if regexm(seller,"PARKER")==1 & regexm(seller,"ORLEANS")==1
	replace seller = "CROSSMANN" if substr(seller,1,9)=="CROSSMANN" & year<2003
	replace seller = "BEAZER" if substr(seller,1,9)=="CROSSMANN" & year>=2003
	replace seller = "DRHORTON" if substr(seller,1,3)=="DRH"
	replace seller = "HISTORYMAKER" if seller == "HMHLIFESTYLES"
	replace seller = "PULTE" if substr(seller,1,4)=="OBRA" & year>=2003
	replace seller = "OBRA" if substr(seller,1,4)=="OBRA" & year<2003
	replace seller = "HOVNANIAN" if substr(seller,1,9)=="NEWFORTIS"
	replace seller = "DRHORTON" if seller=="MELODY"
	replace seller = "TAYLORWOODROW" if substr(seller,1,2) == "TW"
	replace seller = "LENNAR" if substr(seller,1,15)=="VILLAGEBUILDERS"
	replace seller = "DRHORTON" if seller=="KDB"
	replace seller = "ELITEPROPSAMERICA" if seller=="CLASSIC"
	replace seller = "TURNBERRYMGMGRAND" if regexm(seller,"TURNBERRYMGMGRAND")==1
	replace seller = "RYLAND" if seller=="TREND" & year>=2012
	replace seller = "WILLIAMLYON" if year>=2012 & seller=="VILLAGECOLORAD" | seller=="VILLAGELORADO"
	replace seller = "MERITAGE" if seller=="MONTEREYARIZONA" & year>2007
	replace seller = "CALATLANTIC" if seller=="WESTFIELD"  & year>=2002
	replace seller = "LENNAR" if seller=="USHM" 
	replace seller = "CELEBRITY" if seller=="HEARTHSTONE" & year>=2012
	replace seller = "ASHTONWOODS" if substr(seller,1,6)=="ASHTON"
	replace seller = "SHEA" if substr(seller,1,4)=="SHEA" 
	
	replace seller = "DOVER" if regexm(seller,"DOVER")==1 & regexm(seller,"INVESTMENT")==1
	replace seller = "GREENBRICK" if substr(seller,1,10)=="GREENBRICK"
	replace seller = "CALIFORNIACOASTAL" if substr(seller,1,15)=="CALIFORNIACOAST"
	replace seller = "ENGEL" if substr(seller,1,5)=="ENGEL"
	
	replace seller = "NEUMANN" if seller=="NEUMANNCOLORADO" | seller=="NEUMANNMICHIGAN" | seller=="NEUMANNWI" | seller=="NEUMANNWISCONSIN" 
	replace seller = "NEWMARKHOUSTON" if substr(seller,1,7)=="NEWMARK"
	replace seller = "ROYCE" if seller=="ROYCELP" | seller=="ROYCEATLANTA" | seller=="ROYCEDALLAS"
	replace seller = "SARATOGA" if substr(seller,1,8)=="SARATOGA"  
	replace seller = "STYLECRAFT" if substr(seller,1,10)=="STYLECRAFT"
	replace seller = "TRIPOINTE" if seller=="QUADRANT" | substr(seller,1,7)=="MARACAY"   | seller=="TRENDMAKER" 
	replace seller = "TH" if substr(seller,1,3)=="TH "
	replace seller = "TOUSA" if substr(seller,1,5)=="ENGLE"
	replace seller = "WESTPORT" if substr(seller,1,8)=="WESTPORT"  | substr(seller,1,8)=="WESTPORT" 
	replace seller = "MHI" if substr(seller,1,8)=="WILSHIRE" 



	replace seller = "ARMADILLO" if seller=="ARMADILLCO" | seller=="ARMADILLOCOAUSTIN" | seller=="ARMADILLOCOHOUSTON" | seller=="ARMADILLOCOMPANY" | seller=="ARMADILLOCOMPANYAUSTIN" | seller=="ARMADILLOCONSTRUCTIONCO" ///
		| seller=="ARMADILLOCONSTAUSTIN" | seller=="ARMADILLOCONSTCO" | seller=="ARMADILLOCONSTRUCTIONCO"  | seller=="ARMADILLOS" | seller=="ARMADILLOSCO" | seller=="ARMADILLOSCOHOU"
	replace seller="ASHTONWOODS" if "ASHTONWOODS"==substr(seller,1,11) 		
	replace seller="AV" if substr(seller,1,5)=="AVHMS" | substr(seller,1,6)=="AVATAR" | substr(seller,1,8)=="BONTERRA" | substr(seller,1,9)=="ROYALOAKS" 
	replace seller="BLOOMFIELD" if seller=="BLOOMFIELDEQUITY"  | seller=="BLOOMFIELDLP" 
	replace seller = "CASTLEROCKCOMMUNITIES" if seller=="CASTLEROCKCOMMUNITIESLP" 
	replace seller = "CALATLANTIC" if substr(seller,1,10)=="CENTERLINE" & year>=2013  | seller=="STANDARDPACIFIC"
	replace seller = "CENTERLINE" if substr(seller,1,10)=="CENTERLINE" & year<2013 
	replace seller = "CHELDAN" if substr(seller,1,7)=="CHELDAN"
	replace seller = "CPMORGAN" if substr(seller,1,8)=="CPMORGAN"
	replace seller = "CRAFTMARK" if substr(seller,1,9)=="CRAFTMARK"
	replace seller = "DANRYAN" if substr(seller,1,7)=="DANRYAN"
	replace seller = "DARLING" if seller=="DARLINGHOUSTON" & year<2012 | seller=="DARLINGTEXAS" & year<2012 | seller=="DARLINGDALLAS" & year<2012 ///
		| substr(seller,1,8)=="DARLINGH" & year<2012
	replace seller = "TAYLORMORRISON" if seller=="DARLING" & year>=2012
	replace seller = "WEEKLEY" if substr(seller,1,12)=="DAVIDWEEKLEY" | substr(seller,1,7)=="WEEKLEY"
	
	replace seller = "DREES" if regexm(seller,"DREES")==1
	replace seller = "FIELDSTONE" if substr(seller,1,10)=="FIELDSTONE" 
	replace seller = "FISCHER" if substr(seller,1,14)=="FISCHERATTACHED" | substr(seller,1,16)=="FISCHERSINGLEFAM"
	replace seller = "FULTON" if substr(seller,1,10)=="FULTONSALE"
	replace seller = "GEMCRAFT" if substr(seller,1,8)=="GEMCRAFT"
	replace seller = "GL" if substr(seller,1,5)=="GLHMS"
	replace seller = "GRAND" if substr(seller,1,7)=="GRAND20"
	replace seller = "H&H" if seller=="H&HCONSTRUCTORS" | seller=="H&HFAYETTEVILLE" | substr(seller,1,3)=="H&H" 
	replace seller = "HARMONY" if substr(seller,1,7)=="HARMONY"
	replace seller = "HHHUNT" if substr(seller,1,6)=="HHHUNT"
	replace seller = "HIGHLAND" if seller=="HIGHLAND-AUSTIN" | seller=="HIGHLAND-HOUSTON" | seller =="HIGHLAND-SANANTONIO"
	replace seller = "HILLSCOMMUNITIES" if substr(seller,1,16)=="HILLSCOMMUNITIES"
	replace seller = "HOVNANIAN" if substr(seller,1,7)=="KHOVNAN"
	replace seller = "ICI" if substr(seller,1,3)=="ICI"
	replace seller = "IDEAL" if substr(seller,1,11)=="IDEALNORMAN"
	replace seller = "KEYSTONECUSTOM" if seller=="KEYSTONEDEVCO" 
	replace seller = "KIMBALLHILL" if substr(seller,1,11)=="KIMBALLHILL"
	replace seller = "LAKEWOOD" if  substr(seller,1,8)=="LAKEWOOD" 
	replace seller = "LANDON" if seller=="LANDONLP"
	replace seller = "LOMBARDO" if substr(seller,1,8)=="LOMBARDO"
	replace seller = "MATTAMY" if substr(seller,1,7)=="MATTAMY" | substr(seller,1,7)=="MONARCH"
	replace seller = "MCCAR" if seller=="MCCARRALEIGH" | seller=="MCCARBUILDERS" | seller=="MCCARHMS" | seller=="MCCARDEV" ///
		| seller=="MCCARDEVELOPMENT" | substr(seller,1,6)=="MCCAR-"
	replace seller = "MDC" if substr(seller,1,15)=="RICHMONDAMERICA"
	replace seller = "MHI" if substr(seller,1,3)=="MHI" | substr(seller,1,8)=="WILSHIRE" | substr(seller,1,8)=="COVENTRY"  ///
		| substr(seller,1,10)=="PLANTATION" 

	replace seller = "NOVARE" if substr(seller,1,6)=="NOVARE"  | substr(seller,1,6)=="NOVARE" 
	replace seller = "ORLEANS" if substr(seller,1,7)=="ORLEANS"
	replace seller = "PEACHTREECOMMUNITIES" if substr(seller,1,9)=="PEACHTREE" & year<=2014
	replace seller = "CENTURYCOMMUNITIES" if substr(seller,1,9)=="PEACHTREE" & year>2014
	replace seller = "RAUSCHCOLEMAN" if substr(seller,1,13)=="RAUSCHCOLEMAN" 
	replace seller = "S&A" if substr(seller,1,3)=="S&A"
	replace seller = "SHEA" if substr(seller,1,6)=="JFSHEA" | seller=="SHEAREALESTATEINVS" | seller=="SHEALP" | seller=="SHEALIMITEDPARTNER" ///
		| seller=="SHEALAQUINTA" | seller=="SHEAHMSLP" | seller=="SHEAHMS" | seller=="SHEACOMMUNITIESMARKETING " ///
		| seller=="SHEAARIZONA" | seller=="SHEAARIZONALP"  | seller== "SHEAARIZONALIMITED" | seller=="SHEAATMONTAGE" ///
		| seller=="SHEA-HOLLISTER" | seller=="SHEACOMM&POWERRANCHMARKETING" | seller=="SHEACOMMATPOWERRANCH" ///
		| seller=="SHEAPHOENIX" | seller=="SHEAMONTAGE" | seller=="SHEAREALESTATEINVS" | seller=="SHEASOUTHWEST" ///
		| seller=="SHEAVICTORIAGARDENS" | seller=="SHEARIVERPARKDEVELOPERS"
	replace seller = "SHUGARTENTERPRISES" if seller=="SHUGARTENTS" | seller=="SHUGARTMANAGEMENT"
	replace seller = "SIGNATURE" if substr(seller,1,9)=="SIGNATURE"   ///
		| substr(seller,1,9)=="SIGNATURE" 
	replace seller = "SIMMONS" if substr(seller,1,9)=="SIMMONSHM"  | substr(seller,1,10)=="SIMMONSRES"   
	replace seller = "SMITHDOUGLASCOMMUNITIES" if substr(seller,1,14)=="SMITHDOUGHLASHM"
	replace seller = "STANDARDPACIFIC" if substr(seller,1,15)=="STANDARDPACIFIC"
	replace seller = "SUMMERHILL" if substr(seller,1,10)=="SUMMERHILL" 
	replace seller = "TAYLORMORRISON" if substr(seller,1,14)=="TAYLORMORRISON" | seller=="DARLINGHOUSTON" & year>=2012 | seller=="DARLINGTEXAS" & year>=2012 | seller=="DARLINGDALLAS" & year>=2012 ///
		| substr(seller,1,8)=="DARLINGH" & year>=2012 | substr(seller,1,8)=="MORRISON" & year>2008 | ///
		substr(seller,1,13)=="TAYLORWOODROW" & year>2008
	replace seller = "MORRISON" if substr(seller,1,8)=="MORRISON" & year<=2008
	replace seller = "TAYLORWOODROW" if substr(seller,1,13)=="TAYLORWOODROW" & year<=2008
	replace seller = "THEKNIGHT" if substr(seller,1,9)=="THEKNIGHT"  | seller=="KNIGHT"  /// 
		| seller=="KNIGHTGRP" 
	replace seller = "TOLLBROTHERS" if substr(seller,1,6)=="TOLLCA" | substr(seller,1,8)=="TOLLLAND" | substr(seller,1,10)=="TOLLDALLAS" ///
		| substr(seller,1,9)=="TOLLSOUTH" | substr(seller,1,13)=="RANCHOCOSTERA" | substr(seller,1,8)=="TOLLHOUS" ///
		| substr(seller,1,9)=="DOLINGTON" | substr(seller,1,14)=="COLDSPRINGHUNT" | substr(seller,1,17)=="WATERFORDPRESERVE"  ///
		|  substr(seller,1,3)=="TBI" | substr(seller,1,7)=="SHAPELL"
	replace seller = "TRUEUSA" if substr(seller,1,4)=="TRUE"  | substr(seller,1,4)=="TRUE"   ///
		| seller=="CRAFT"  | seller=="CRAFT"  |  seller=="CRAFTUSA"   ///
		| seller=="CRAFTUSA"  
	replace seller = "UNITED-BUILT" if  substr(seller,1,8)=="UNITED-B"
	replace seller = "WESTHILLSDEVELOPMENT" if substr(seller,1,12)=="WESTHILLSDEV"
	replace seller = "WESTIN" if substr(seller,1,6)=="WESTIN" 
	replace seller = "WILLIAMLYON" if substr(seller,1,11)=="WILLIAMLYON"
	replace seller = "WILLIAMRYAN" if substr(seller,1,11)=="WILLIAMRYAN"
	replace seller = "WL" if substr(seller,1,9)=="JOHNLAING" | seller=="WATT" | substr(seller,1,5)=="WATT-"
	replace seller = "WOODSIDE" if substr(seller,1,8)=="WOODSIDE"  | substr(seller,1,8)=="WOODSIDE"  ///
			| substr(seller,1,8)=="WOODSIDE"  | substr(seller,1,8)=="WOODSIDE"  ///
			| substr(seller,1,8)=="WOODSIDE"  
}
else if "`1'"=="dealscan" {
		
	replace seller = "AMERICASFIRST" if substr(seller,1,13)=="AMERICASFIRST"
	replace seller = "ARBOR" if substr(seller,1,5)=="ARBOR" 
	replace seller = "ARMADILLO" if substr(seller,1,9)=="ARMADILLO"
	replace seller = "ANGLIA" if seller=="ANGLIALP"
	replace seller = "AV" if seller=="AVATAR" | seller=="AV(FORMERLYAVATAR)"
	replace seller = "BALL" if seller=="BALLHMS" 
	replace seller = "BOWENFAMILY" if seller=="BOWENBUILDERS" | substr(seller,1,9)=="BOWENBLDR" | substr(seller,1,11)=="BOWENFAMILY"
	replace seller = "CAPITALPACIFIC" if substr(seller,1,14)=="CAPITALPACIFIC"
	replace seller = "CASALINDA" if substr(seller,1,9)=="CASALINDA"
	replace seller = "CHESMAR" if substr(seller,1,7)=="CHESMAR"
	replace seller = "DESERTVIEW" if substr(seller,1,10)=="DESERTVIEW"
	replace seller = "DRHORTON" if seller=="CONTINENTALTEXAS"
	replace seller = "EASTWOOD" if seller=="EASTWOODCO" | seller=="EASTWOODRALEIGH" | seller=="EASTWOODSTAUGUSTINE"
	replace seller = "ELLIOTT" if seller=="ELLIOTTARIZONA" | seller=="ELLIOTTHMS" | seller=="ELLIOTTRESIDENTIAL"
	replace seller = "FIELDSTONECOMMUNITIES" if substr(seller,1,16)=="FIELDSTONECOMMUN" 
	replace seller = "HAYDEN" if seller=="HAYDENENTS" | seller=="HAYDENENTERPRISES" | seller=="HAYDENENT" | seller=="HAYDENCO" | seller=="HAYDENIDAHO"
	replace seller = "HEARTLAND" if substr(seller,1,9)=="HEARTLAND" 
	replace seller = "NVR" if seller=="RYAN" | seller=="FOXRIDGE"  // subsidiaries of nvr
	replace seller = "HOLIDAYBUILDERS" if substr(seller,1,8)=="HOLIDAYB" | regexm(seller,"HOLIDAYBUILDER")==1
	replace seller = "IVORY" if substr(seller,1,5)=="IVORY" 
	replace seller = "KB" if seller=="KAUFMAN&BROAD" | substr(seller,1,13)=="KAUFMAN&BROAD" | substr(seller,1,15)=="KAUFMANANDBROAD"
	replace seller = "LENNAR" if seller=="GREYSTONE"  | seller=="US" & year>2000  | seller=="US HOME CORP"  // this is subs
	replace seller = "MARONDA" if substr(seller,1,7)=="MARONDA"
	replace seller = "MERCEDES" if substr(seller,1,9)=="MERCEDEST" | substr(seller,1,10)=="MERCEDESHM"
	replace seller = "MERITAGE" if substr(seller,1,4)=="MTH-"
	replace seller = "M/I" if regexm(seller,"SCHOTTENSTEIN")==1
	replace seller = "MINTOCOMMUNITIES" if substr(seller,1,8)=="MINTOCOM"
	replace seller = "MONTALBANOBUILDERS" if substr(seller,1,10)=="MONTALBANO"
	
	
	replace seller = "AV" if substr(seller,1,6)=="AVATAR"
	replace seller = "MERCEDES" if substr(seller,1,8)=="MERCEDES"   
	replace seller = "TOUSA" if substr(seller,1,7)=="NEWMARK" | substr(seller,1,6)=="TROPHY"
	replace seller = "DRHORTON" if substr(seller,1,21)=="WESTERNPACIFICHOUSING"
	replace seller = "MERITAGE" if regexm(seller,"LEGACY")==1 & regexm(seller,"MONTEREY")==1
	replace seller = "HOVNANIAN" if substr(seller,1,12)=="FIRSTBUILDER"
	replace seller = "TOUSA" if substr(seller,1,16)=="TECHNICALOLYMPIC"
	replace seller = "TOUSA" if regexm(seller,"TRANSEASTERN")==1
	replace seller = "PULTE" if substr(seller,1,7)=="WEBBDEL"
	replace seller = "ADAMS" if regexm(seller,"ADAMS")==1 & regexm(seller,"NORTHWEST")==1 | substr(seller,1,10)=="ADAMSNORTH"
	replace seller = "HOVNANIAN" if substr(seller,1,13)=="GOODMANFAMILY"
	replace seller = "CBH" if substr(seller,1,11)=="COREYBARTON"
	replace seller = "ORLEANS" if substr(seller,1,8)=="ROTTLUND" & year>2001
	replace seller = "ORLEANS" if regexm(seller,"PARKER")==1 & regexm(seller,"ORLEANS")==1
	replace seller = "CROSSMANN" if substr(seller,1,9)=="CROSSMANN" & year<2003
	replace seller = "BEAZER" if substr(seller,1,9)=="CROSSMANN" & year>=2003
	replace seller = "DRHORTON" if substr(seller,1,3)=="DRH"
	replace seller = "HISTORYMAKER" if seller == "HMHLIFESTYLES"
	replace seller = "PULTE" if substr(seller,1,4)=="OBRA" & year>=2003
	replace seller = "OBRA" if substr(seller,1,4)=="OBRA" & year<2003
	replace seller = "HOVNANIAN" if substr(seller,1,9)=="NEWFORTIS"
	replace seller = "DRHORTON" if seller=="MELODY"
	replace seller = "TAYLORWOODROW" if substr(seller,1,2) == "TW"
	replace seller = "LENNAR" if substr(seller,1,15)=="VILLAGEBUILDERS"
	replace seller = "DRHORTON" if seller=="KDB"
	replace seller = "ELITEPROPSAMERICA" if seller=="CLASSIC"
	replace seller = "TURNBERRYMGMGRAND" if regexm(seller,"TURNBERRYMGMGRAND")==1
	replace seller = "RYLAND" if seller=="TREND" & year>=2012
	replace seller = "WILLIAMLYON" if year>=2012 & seller=="VILLAGECOLORAD" | seller=="VILLAGELORADO"
	replace seller = "MERITAGE" if seller=="MONTEREYARIZONA" & year>2007
	replace seller = "CALATLANTIC" if seller=="WESTFIELD"  & year>=2002
	replace seller = "LENNAR" if seller=="USHM" 
	replace seller = "CELEBRITY" if seller=="HEARTHSTONE" & year>=2012
	replace seller = "ASHTONWOODS" if substr(seller,1,6)=="ASHTON"
	replace seller = "SHEA" if substr(seller,1,4)=="SHEA" 
	
	replace seller = "DOVER" if regexm(seller,"DOVER")==1 & regexm(seller,"INVESTMENT")==1
	replace seller = "GREENBRICK" if substr(seller,1,10)=="GREENBRICK"
	replace seller = "CALIFORNIACOASTAL" if substr(seller,1,15)=="CALIFORNIACOAST"
	replace seller = "ENGEL" if substr(seller,1,5)=="ENGEL"
	
	replace seller = "NEUMANN" if seller=="NEUMANNCOLORADO" | seller=="NEUMANNMICHIGAN" | seller=="NEUMANNWI" | seller=="NEUMANNWISCONSIN" 
	replace seller = "NEWMARKHOUSTON" if substr(seller,1,7)=="NEWMARK"
	replace seller = "ROYCE" if seller=="ROYCELP" | seller=="ROYCEATLANTA" | seller=="ROYCEDALLAS"
	replace seller = "SARATOGA" if substr(seller,1,8)=="SARATOGA" 
	replace seller = "STYLECRAFT" if substr(seller,1,10)=="STYLECRAFT"
	replace seller = "TRIPOINTE" if seller=="QUADRANT" | substr(seller,1,7)=="MARACAY" | seller=="TRENDMAKER" 
	replace seller = "TH" if substr(seller,1,3)=="TH "
	replace seller = "TOUSA" if substr(seller,1,5)=="ENGLE"
	replace seller = "WESTPORT" if substr(seller,1,8)=="WESTPORT" | substr(seller,1,8)=="WESTPORT" 
	replace seller = "MHI" if substr(seller,1,8)=="WILSHIRE" 



	replace seller = "ARMADILLO" if seller=="ARMADILLCO" | seller=="ARMADILLOCOAUSTIN" | seller=="ARMADILLOCOHOUSTON" | seller=="ARMADILLOCOMPANY" | seller=="ARMADILLOCOMPANYAUSTIN" | seller=="ARMADILLOCONSTRUCTIONCO" ///
		| seller=="ARMADILLOCONSTAUSTIN" | seller=="ARMADILLOCONSTCO" | seller=="ARMADILLOCONSTRUCTIONCO"  | seller=="ARMADILLOS" | seller=="ARMADILLOSCO" | seller=="ARMADILLOSCOHOU"
	replace seller="ASHTONWOODS" if "ASHTONWOODS"==substr(seller,1,11) 		
	replace seller="AV" if substr(seller,1,5)=="AVHMS" | substr(seller,1,6)=="AVATAR" | substr(seller,1,8)=="BONTERRA" | substr(seller,1,9)=="ROYALOAKS" 
	replace seller="BLOOMFIELD" if seller=="BLOOMFIELDEQUITY" | seller=="BLOOMFIELDLP" 
	replace seller = "CASTLEROCKCOMMUNITIES" if seller=="CASTLEROCKCOMMUNITIESLP" 
	replace seller = "CALATLANTIC" if substr(seller,1,10)=="CENTERLINE" | seller=="STANDARDPACIFIC"
	replace seller = "CENTERLINE" if substr(seller,1,10)=="CENTERLINE" 
	replace seller = "CHELDAN" if substr(seller,1,7)=="CHELDAN"
	replace seller = "CPMORGAN" if substr(seller,1,8)=="CPMORGAN"
	replace seller = "CRAFTMARK" if substr(seller,1,9)=="CRAFTMARK"
	replace seller = "DANRYAN" if substr(seller,1,7)=="DANRYAN"
	replace seller = "DARLING" if seller=="DARLINGHOUSTON" | seller=="DARLINGTEXAS" | seller=="DARLINGDALLAS" ///
		| substr(seller,1,8)=="DARLINGH" 
	replace seller = "TAYLORMORRISON" if seller=="DARLING" 
	replace seller = "WEEKLEY" if substr(seller,1,12)=="DAVIDWEEKLEY" | substr(seller,1,7)=="WEEKLEY"
	replace seller = "DREES" if regexm(seller,"DREES")==1
	replace seller = "FIELDSTONE" if substr(seller,1,10)=="FIELDSTONE" 
	replace seller = "FISCHER" if substr(seller,1,14)=="FISCHERATTACHED" | substr(seller,1,16)=="FISCHERSINGLEFAM"
	replace seller = "FULTON" if substr(seller,1,10)=="FULTONSALE"
	replace seller = "GEMCRAFT" if substr(seller,1,8)=="GEMCRAFT"
	replace seller = "GL" if substr(seller,1,5)=="GLHMS"
	replace seller = "GRAND" if substr(seller,1,7)=="GRAND20"
	replace seller = "H&H" if seller=="H&HCONSTRUCTORS" | seller=="H&HFAYETTEVILLE" | substr(seller,1,3)=="H&H" 
	replace seller = "HARMONY" if substr(seller,1,7)=="HARMONY"
	replace seller = "HHHUNT" if substr(seller,1,6)=="HHHUNT"
	replace seller = "HIGHLAND" if seller=="HIGHLAND-AUSTIN" | seller=="HIGHLAND-HOUSTON" | seller =="HIGHLAND-SANANTONIO"
	replace seller = "HILLSCOMMUNITIES" if substr(seller,1,16)=="HILLSCOMMUNITIES"
	replace seller = "HOVNANIAN" if substr(seller,1,7)=="KHOVNAN"
	replace seller = "ICI" if substr(seller,1,3)=="ICI"
	replace seller = "IDEAL" if substr(seller,1,11)=="IDEALNORMAN"
	replace seller = "KEYSTONECUSTOM" if seller=="KEYSTONEDEVCO" 
	replace seller = "KIMBALLHILL" if substr(seller,1,11)=="KIMBALLHILL"
	replace seller = "LAKEWOOD" if  substr(seller,1,8)=="LAKEWOOD" 
	replace seller = "LANDON" if seller=="LANDONLP"
	replace seller = "LOMBARDO" if substr(seller,1,8)=="LOMBARDO"
	replace seller = "MATTAMY" if substr(seller,1,7)=="MATTAMY" | substr(seller,1,7)=="MONARCH"
	replace seller = "MCCAR" if seller=="MCCARRALEIGH" | seller=="MCCARBUILDERS" | seller=="MCCARHMS" | seller=="MCCARDEV" ///
		| seller=="MCCARDEVELOPMENT" | substr(seller,1,6)=="MCCAR-"
	replace seller = "MDC" if substr(seller,1,15)=="RICHMONDAMERICA"
	replace seller = "MHI" if substr(seller,1,3)=="MHI" | substr(seller,1,8)=="WILSHIRE" | substr(seller,1,8)=="COVENTRY" ///
		| substr(seller,1,10)=="PLANTATION" 

	
	replace seller = "NOVARE" if substr(seller,1,6)=="NOVARE"  | substr(seller,1,6)=="NOVARE" 
	replace seller = "ORLEANS" if substr(seller,1,7)=="ORLEANS"
	replace seller = "PEACHTREECOMMUNITIES" if substr(seller,1,9)=="PEACHTREE" 
	replace seller = "CENTURYCOMMUNITIES" if substr(seller,1,9)=="PEACHTREE" 
	replace seller = "RAUSCHCOLEMAN" if substr(seller,1,13)=="RAUSCHCOLEMAN" 
	replace seller = "S&A" if substr(seller,1,3)=="S&A"
	replace seller = "SHEA" if substr(seller,1,6)=="JFSHEA" | seller=="SHEAREALESTATEINVS" | seller=="SHEALP" | seller=="SHEALIMITEDPARTNER" ///
		| seller=="SHEALAQUINTA" | seller=="SHEAHMSLP" | seller=="SHEAHMS" | seller=="SHEACOMMUNITIESMARKETING " ///
		| seller=="SHEAARIZONA" | seller=="SHEAARIZONALP"  | seller== "SHEAARIZONALIMITED" | seller=="SHEAATMONTAGE" ///
		| seller=="SHEA-HOLLISTER" | seller=="SHEACOMM&POWERRANCHMARKETING" | seller=="SHEACOMMATPOWERRANCH" ///
		| seller=="SHEAPHOENIX" | seller=="SHEAMONTAGE" | seller=="SHEAREALESTATEINVS" | seller=="SHEASOUTHWEST" ///
		| seller=="SHEAVICTORIAGARDENS" | seller=="SHEARIVERPARKDEVELOPERS"
	replace seller = "SHUGARTENTERPRISES" if seller=="SHUGARTENTS" | seller=="SHUGARTMANAGEMENT"
	replace seller = "SIGNATURE" if substr(seller,1,9)=="SIGNATURE"  ///
		| substr(seller,1,9)=="SIGNATURE" 
	replace seller = "SIMMONS" if substr(seller,1,9)=="SIMMONSHM" | substr(seller,1,10)=="SIMMONSRES" 
	replace seller = "SMITHDOUGLASCOMMUNITIES" if substr(seller,1,14)=="SMITHDOUGHLASHM"
	replace seller = "STANDARDPACIFIC" if substr(seller,1,15)=="STANDARDPACIFIC"
	replace seller = "SUMMERHILL" if substr(seller,1,10)=="SUMMERHILL" 
	replace seller = "TAYLORMORRISON" if substr(seller,1,14)=="TAYLORMORRISON" | seller=="DARLINGHOUSTON" | seller=="DARLINGTEXAS" | seller=="DARLINGDALLAS" ///
		| substr(seller,1,8)=="DARLINGH" | substr(seller,1,8)=="MORRISON" | ///
		substr(seller,1,13)=="TAYLORWOODROW" 
	replace seller = "MORRISON" if substr(seller,1,8)=="MORRISON" 
	replace seller = "TAYLORWOODROW" if substr(seller,1,13)=="TAYLORWOODROW" 
	replace seller = "THEKNIGHT" if substr(seller,1,9)=="THEKNIGHT" | seller=="KNIGHT" /// 
		| seller=="KNIGHTGRP" 
	replace seller = "TOLLBROTHERS" if substr(seller,1,6)=="TOLLCA" | substr(seller,1,8)=="TOLLLAND" | substr(seller,1,10)=="TOLLDALLAS" ///
		| substr(seller,1,9)=="TOLLSOUTH" | substr(seller,1,13)=="RANCHOCOSTERA" | substr(seller,1,8)=="TOLLHOUS" ///
		| substr(seller,1,9)=="DOLINGTON" | substr(seller,1,14)=="COLDSPRINGHUNT" | substr(seller,1,17)=="WATERFORDPRESERVE"  ///
		|  substr(seller,1,3)=="TBI" | substr(seller,1,7)=="SHAPELL"
	replace seller = "TRUEUSA" if substr(seller,1,4)=="TRUE" | substr(seller,1,4)=="TRUE" ///
		| seller=="CRAFT" | seller=="CRAFT" |  seller=="CRAFTUSA" ///
		| seller=="CRAFTUSA" 
	replace seller = "UNITED-BUILT" if  substr(seller,1,8)=="UNITED-B"
	replace seller = "WESTHILLSDEVELOPMENT" if substr(seller,1,12)=="WESTHILLSDEV"
	replace seller = "WESTIN" if substr(seller,1,6)=="WESTIN" 
	replace seller = "WILLIAMLYON" if substr(seller,1,11)=="WILLIAMLYON"
	replace seller = "WILLIAMRYAN" if substr(seller,1,11)=="WILLIAMRYAN"
	replace seller = "WL" if substr(seller,1,9)=="JOHNLAING" | seller=="WATT" | substr(seller,1,5)=="WATT-"
	replace seller = "WOODSIDE" if substr(seller,1,8)=="WOODSIDE" | substr(seller,1,8)=="WOODSIDE" ///
			| substr(seller,1,8)=="WOODSIDE"  | substr(seller,1,8)=="WOODSIDE" ///
			| substr(seller,1,8)=="WOODSIDE" 
			
}
